package com.sgam.mf.domain.entity;

import java.util.Date;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import org.codehaus.jackson.map.annotate.JsonDeserialize;
import org.codehaus.jackson.map.annotate.JsonSerialize;
import org.springframework.format.annotation.DateTimeFormat;

import com.sgam.mf.domain.ref.RefActivityType;
import com.sgam.utils.CustomDateDeserializer;
import com.sgam.utils.CustomDateSerializer;

@Entity
@Table(name = "APPLICATION_PERS_JUR")
public class ApplicationPersJur {


	@Id
	@Column(name = "id")
	@GeneratedValue
	private Integer id;

//	@ManyToOne
//	@JoinColumn(name = "contract_fk", nullable = true) 
//	private Contracts contracts;
	
	@Column(name = "idno") 
	private String idno;
	
	@Column(name = "name") 
	private String name;
	
	@Column(name = "phone") 
	private String phone;
	
	@Column(name = "status", nullable = true) 
	private Integer status;
	
	@Column(name = "updated_by_fk", nullable = true) 
	private Integer updatedByFk;
	
	@JsonSerialize(using = CustomDateSerializer.class)
	@JsonDeserialize(using = CustomDateDeserializer.class)
	@DateTimeFormat(pattern="dd.MM.yyyy")
	@Column(name = "updated_date", nullable = true) 
	private Date updatedDate;
	 
	@ManyToOne(cascade = CascadeType.ALL)
	@JoinColumn(name = "reg_companies_fk") 
	private RegCompanies regCompanies;

	@Column(name = "address") 
	private String address;
	
	@Column(name = "ref_property_type_fk") 
	private Integer refPropertyTypeFk;

	@Column(name = "gaj_flg") 
	private Integer gajFlg;
	
//	@Column(name = "activity_type") 
//	private String activityType;
	
	@ManyToOne
	@JoinColumn(name = "ref_activity_type_fk") 
	private RefActivityType refActivityType;
  
	@Column(name = "afiate_companys") 
	private Integer afiateCompanys;
	
	@Column(name = "credit_history_flg") 
	private Integer creditHistoryFlg;
	
	@Column(name = "positive_hostory_flg") 
	private Integer positiveHostoryFlg;
	  
	@Column(name = "credit_amount") 
	private String creditAmount;
	
	@Column(name = "credit_time") 
	private String creditTime;
	
	@Column(name = "credit_destination") 
	private String creditDestination;
	
	@Column(name = "sale_revenue") 
	private String saleRevenue;
	
	@Column(name = "profit") 
	private String profit;

	@Column(name = "debt") 
	private String debt;
	
	@Column(name = "crente") 
	private String crente;
	
	@Column(name = "state_capital") 
	private String stateCapital;
	
	@Column(name = "employer_number") 
	private String employerNumber;
	
	@Column(name = "aboard_grad_rud") 
	private String aboardGradRud;
	
	@Column(name = "aboard_tara") 
	private String aboardTara;
	
	@Column(name = "aboard_vechime") 
	private String aboardVechime;
	
	@Column(name = "aboard_legal") 
	private Integer aboardLegal;
	
	@Column(name = "another_info") 
	private String anotherInfo;
	
	@Column(name = "martial_status") 
	private Integer martialStatus;
	
//	@Column(name = "husband_age") 
//	private String husbandAge; 
	
	@JsonSerialize(using = CustomDateSerializer.class)
	@JsonDeserialize(using = CustomDateDeserializer.class)
	@DateTimeFormat(pattern="dd.MM.yyyy")
	@Column(name = "husband_age", nullable = true) 
	private Date husbandAge;
	
	@Column(name = "children") 
	private Integer children;
	
	@Column(name = "children_age") 
	private  String childrenAge;
	
	@Column(name = "gaj") 
	private String gaj;
	//-----------------------------------------
	@Column(name = "contract_banca") 
	private String contractBanca;
	
	@Column(name = "contract_company") 
	private String contractCompany;
	
	@Column(name = "contract_another") 
	private String contractAnother;
	
	@Column(name = "val_plata") 
	private String valPlata;
	
	@Column(name = "val_lichidarea") 
	private String valLichidarea;
	
	@Column(name = "val_inloc") 
	private String valInloc;
	
	@Column(name = "suma_atrasa") 
	private String sumaAtrasa;
	
	@Column(name = "aport_companie") 
	private String aportCompanie;
	
	@Column(name = "total") 
	private String total;
	
	@Column(name = "experienta") 
	private String experienta;
	
	@Column(name = "produse") 
	private String produse;
	
	@Column(name = "capacitatea") 
	private String capacitatea;
	
	@Column(name = "valoare_de_plata") 
	private String valoareDePlata;
	
	@Column(name = "valoare_de_plata_curr_fk") 
	private Integer valoareDePlataCurrFk;
	
//----MM Proiect	

	
	@Column(name = "p_termen_credit") 
	private String pTermenCredit;
	
	@Column(name = "p_rata_dob") 
	private String pRataDob;
	
	@Column(name = "p_vacanta_credit") 
	private String pVacantaCredit;
	
	@Column(name = "p_vacanta_dob") 
	private String pVacantaDob;
	
	@Column(name = "p_mod_achit") 
	private String pModAchit;
	
	@Column(name = "p_activ_pro") 
	private String pActivPro;
	
	@Column(name = "p_luna_imp") 
	private String pLunaImp;
	
	@Column(name = "p_cant_prod") 
	private String pCantProd;
	
	@Column(name = "p_pret") 
	private String pPret;
	
	@Column(name = "p_adr_activ") 
	private String pAdrActiv;
	
//----MM Compania
	
	@Column(name = "c_forma_org") 
	private String cFormaOrg;
	
	@Column(name = "c_adr") 
	private String cAdr;
	
	@Column(name = "c_incaperi") 
	private String cIncaperi;
	
	@Column(name = "c_teren") 
	private String cTeren;
	
	@Column(name = "c_teren_arenda") 
	private String cTerenArenda;
	
	@Column(name = "c_prod") 
	private String cProd;
	
	@Column(name = "c_serv") 
	private String cServ;
	
	@Column(name = "c_animal") 
	private String cAnimal;

//----MM Management
	
	@Column(name = "m_admin") 
	private String mAdmin;
	
	@Column(name = "m_adm_experience") 
	private String mAdmExperience;
	
	@Column(name = "m_contabil") 
	private String mContabil;
	
	@Column(name = "m_cont_experience") 
	private String mContExperience;
	
	@Column(name = "m_personal_ex") 
	private String mPersonalEx;
	
	@Column(name = "m_personal_nou") 
	private String mPersonalNou;
	
//----MM Marcheting
	
	@Column(name = "ma_piata") 
	private String maPiata;
	
	@Column(name = "ma_furnizor") 
	private String maFurnizor;
	
	@Column(name = "ma_concurenti") 
	private String maConcurenti;
	
	
	
	
	
	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

//	public Contracts getContracts() {
//		return contracts;
//	}
//
//	public void setContracts(Contracts contracts) {
//		this.contracts = contracts;
//	}

	public String getIdno() {
		return idno;
	}

	public void setIdno(String idno) {
		this.idno = idno;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public Integer getStatus() {
		return status;
	}

	public void setStatus(Integer status) {
		this.status = status;
	}

	public Integer getUpdatedByFk() {
		return updatedByFk;
	}

	public void setUpdatedByFk(Integer updatedByFk) {
		this.updatedByFk = updatedByFk;
	}

	public Date getUpdatedDate() {
		return updatedDate;
	}

	public void setUpdatedDate(Date updatedDate) {
		this.updatedDate = updatedDate;
	}

	public RegCompanies getRegCompanies() {
		return regCompanies;
	}

	public void setRegCompanies(RegCompanies regCompanies) {
		this.regCompanies = regCompanies;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public Integer getRefPropertyTypeFk() {
		return refPropertyTypeFk;
	}

	public void setRefPropertyTypeFk(Integer refPropertyTypeFk) {
		this.refPropertyTypeFk = refPropertyTypeFk;
	}

	public Integer getGajFlg() {
		return gajFlg;
	}

	public void setGajFlg(Integer gajFlg) {
		this.gajFlg = gajFlg;
	}

//	public String getActivityType() {
//		return activityType;
//	}
//
//	public void setActivityType(String activityType) {
//		this.activityType = activityType;
//	}
	
	public RefActivityType getRefActivityType() {
		return refActivityType;
	}

	public void setRefActivityType(RefActivityType refActivityType) {
		this.refActivityType = refActivityType;
	}

	public Integer getAfiateCompanys() {
		return afiateCompanys;
	}


	public void setAfiateCompanys(Integer afiateCompanys) {
		this.afiateCompanys = afiateCompanys;
	}

	public Integer getCreditHistoryFlg() {
		return creditHistoryFlg;
	}

	public void setCreditHistoryFlg(Integer creditHistoryFlg) {
		this.creditHistoryFlg = creditHistoryFlg;
	}

	public Integer getPositiveHostoryFlg() {
		return positiveHostoryFlg;
	}

	public void setPositiveHostoryFlg(Integer positiveHostoryFlg) {
		this.positiveHostoryFlg = positiveHostoryFlg;
	}

	public String getCreditAmount() {
		return creditAmount;
	}

	public void setCreditAmount(String creditAmount) {
		this.creditAmount = creditAmount;
	}

	public String getCreditTime() {
		return creditTime;
	}

	public void setCreditTime(String creditTime) {
		this.creditTime = creditTime;
	}

	public String getCreditDestination() {
		return creditDestination;
	}

	public void setCreditDestination(String creditDestination) {
		this.creditDestination = creditDestination;
	}

	public String getSaleRevenue() {
		return saleRevenue;
	}

	public void setSaleRevenue(String saleRevenue) {
		this.saleRevenue = saleRevenue;
	}

	public String getProfit() {
		return profit;
	}

	public void setProfit(String profit) {
		this.profit = profit;
	}

	public String getDebt() {
		return debt;
	}

	public void setDebt(String debt) {
		this.debt = debt;
	}

	public String getCrente() {
		return crente;
	}

	public void setCrente(String crente) {
		this.crente = crente;
	}

	public String getStateCapital() {
		return stateCapital;
	}

	public void setStateCapital(String stateCapital) {
		this.stateCapital = stateCapital;
	}

	public String getEmployerNumber() {
		return employerNumber;
	}

	public void setEmployerNumber(String employerNumber) {
		this.employerNumber = employerNumber;
	}

	public String getAboardGradRud() {
		return aboardGradRud;
	}

	public void setAboardGradRud(String aboardGradRud) {
		this.aboardGradRud = aboardGradRud;
	}

	public String getAboardTara() {
		return aboardTara;
	}

	public void setAboardTara(String aboardTara) {
		this.aboardTara = aboardTara;
	}

	public String getAboardVechime() {
		return aboardVechime;
	}

	public void setAboardVechime(String aboardVechime) {
		this.aboardVechime = aboardVechime;
	}

	public Integer getAboardLegal() {
		return aboardLegal;
	}

	public void setAboardLegal(Integer aboardLegal) {
		this.aboardLegal = aboardLegal;
	}

	public String getAnotherInfo() {
		return anotherInfo;
	}

	public void setAnotherInfo(String anotherInfo) {
		this.anotherInfo = anotherInfo;
	}

//	public String getHusbandAge() {
//		return husbandAge;
//	}
//
//	public void setHusbandAge(String husbandAge) {
//		this.husbandAge = husbandAge;
//	}
	
	
	public Date getHusbandAge() {
		return husbandAge;
	}

	public void setHusbandAge(Date husbandAge) {
		this.husbandAge = husbandAge;
	}
	
	public Integer getChildren() {
		return children;
	}

	public void setChildren(Integer children) {
		this.children = children;
	}

	public String getChildrenAge() {
		return childrenAge;
	}

	public void setChildrenAge(String childrenAge) {
		this.childrenAge = childrenAge;
	}

	public Integer getMartialStatus() {
		return martialStatus;
	}

	public void setMartialStatus(Integer martialStatus) {
		this.martialStatus = martialStatus;
	}

	public String getGaj() {
		return gaj;
	}

	public void setGaj(String gaj) {
		this.gaj = gaj;
	}

	public String getContractBanca() {
		return contractBanca;
	}

	public void setContractBanca(String contractBanca) {
		this.contractBanca = contractBanca;
	}

	public String getContractCompany() {
		return contractCompany;
	}

	public void setContractCompany(String contractCompany) {
		this.contractCompany = contractCompany;
	}

	public String getContractAnother() {
		return contractAnother;
	}

	public void setContractAnother(String contractAnother) {
		this.contractAnother = contractAnother;
	}

	public String getValPlata() {
		return valPlata;
	}

	public void setValPlata(String valPlata) {
		this.valPlata = valPlata;
	}

	public String getValLichidarea() {
		return valLichidarea;
	}

	public void setValLichidarea(String valLichidarea) {
		this.valLichidarea = valLichidarea;
	}

	public String getValInloc() {
		return valInloc;
	}

	public void setValInloc(String valInloc) {
		this.valInloc = valInloc;
	}

	public String getSumaAtrasa() {
		return sumaAtrasa;
	}

	public void setSumaAtrasa(String sumaAtrasa) {
		this.sumaAtrasa = sumaAtrasa;
	}

	public String getAportCompanie() {
		return aportCompanie;
	}

	public void setAportCompanie(String aportCompanie) {
		this.aportCompanie = aportCompanie;
	}

	public String getTotal() {
		return total;
	}

	public void setTotal(String total) {
		this.total = total;
	}

	public String getExperienta() {
		return experienta;
	}

	public void setExperienta(String experienta) {
		this.experienta = experienta;
	}

	public String getProduse() {
		return produse;
	}

	public void setProduse(String produse) {
		this.produse = produse;
	}

	public String getCapacitatea() {
		return capacitatea;
	}

	public void setCapacitatea(String capacitatea) {
		this.capacitatea = capacitatea;
	}

	public String getValoareDePlata() {
		return valoareDePlata;
	}

	public void setValoareDePlata(String valoareDePlata) {
		this.valoareDePlata = valoareDePlata;
	}

	public Integer getValoareDePlataCurrFk() {
		return valoareDePlataCurrFk;
	}

	public void setValoareDePlataCurrFk(Integer valoareDePlataCurrFk) {
		this.valoareDePlataCurrFk = valoareDePlataCurrFk;
	}

	public String getpTermenCredit() {
		return pTermenCredit;
	}

	public void setpTermenCredit(String pTermenCredit) {
		this.pTermenCredit = pTermenCredit;
	}

	public String getpRataDob() {
		return pRataDob;
	}

	public void setpRataDob(String pRataDob) {
		this.pRataDob = pRataDob;
	}

	public String getpVacantaCredit() {
		return pVacantaCredit;
	}

	public void setpVacantaCredit(String pVacantaCredit) {
		this.pVacantaCredit = pVacantaCredit;
	}

	public String getpVacantaDob() {
		return pVacantaDob;
	}

	public void setpVacantaDob(String pVacantaDob) {
		this.pVacantaDob = pVacantaDob;
	}

	public String getpModAchit() {
		return pModAchit;
	}

	public void setpModAchit(String pModAchit) {
		this.pModAchit = pModAchit;
	}

	public String getpActivPro() {
		return pActivPro;
	}

	public void setpActivPro(String pActivPro) {
		this.pActivPro = pActivPro;
	}

	public String getpLunaImp() {
		return pLunaImp;
	}

	public void setpLunaImp(String pLunaImp) {
		this.pLunaImp = pLunaImp;
	}

	public String getpCantProd() {
		return pCantProd;
	}

	public void setpCantProd(String pCantProd) {
		this.pCantProd = pCantProd;
	}

	public String getpPret() {
		return pPret;
	}

	public void setpPret(String pPret) {
		this.pPret = pPret;
	}

	public String getpAdrActiv() {
		return pAdrActiv;
	}

	public void setpAdrActiv(String pAdrActiv) {
		this.pAdrActiv = pAdrActiv;
	}

	public String getcFormaOrg() {
		return cFormaOrg;
	}

	public void setcFormaOrg(String cFormaOrg) {
		this.cFormaOrg = cFormaOrg;
	}

	public String getcAdr() {
		return cAdr;
	}

	public void setcAdr(String cAdr) {
		this.cAdr = cAdr;
	}

	public String getcIncaperi() {
		return cIncaperi;
	}

	public void setcIncaperi(String cIncaperi) {
		this.cIncaperi = cIncaperi;
	}

	public String getcTeren() {
		return cTeren;
	}

	public void setcTeren(String cTeren) {
		this.cTeren = cTeren;
	}

	public String getcTerenArenda() {
		return cTerenArenda;
	}

	public void setcTerenArenda(String cTerenArenda) {
		this.cTerenArenda = cTerenArenda;
	}

	public String getcProd() {
		return cProd;
	}

	public void setcProd(String cProd) {
		this.cProd = cProd;
	}

	public String getcServ() {
		return cServ;
	}

	public void setcServ(String cServ) {
		this.cServ = cServ;
	}

	public String getcAnimal() {
		return cAnimal;
	}

	public void setcAnimal(String cAnimal) {
		this.cAnimal = cAnimal;
	}

	public String getmAdmin() {
		return mAdmin;
	}

	public void setmAdmin(String mAdmin) {
		this.mAdmin = mAdmin;
	}

	public String getmAdmExperience() {
		return mAdmExperience;
	}

	public void setmAdmExperience(String mAdmExperience) {
		this.mAdmExperience = mAdmExperience;
	}

	public String getmContabil() {
		return mContabil;
	}

	public void setmContabil(String mContabil) {
		this.mContabil = mContabil;
	}

	public String getmContExperience() {
		return mContExperience;
	}

	public void setmContExperience(String mContExperience) {
		this.mContExperience = mContExperience;
	}

	public String getmPersonalEx() {
		return mPersonalEx;
	}

	public void setmPersonalEx(String mPersonalEx) {
		this.mPersonalEx = mPersonalEx;
	}

	public String getmPersonalNou() {
		return mPersonalNou;
	}

	public void setmPersonalNou(String mPersonalNou) {
		this.mPersonalNou = mPersonalNou;
	}

	public String getMaPiata() {
		return maPiata;
	}

	public void setMaPiata(String maPiata) {
		this.maPiata = maPiata;
	}

	public String getMaFurnizor() {
		return maFurnizor;
	}

	public void setMaFurnizor(String maFurnizor) {
		this.maFurnizor = maFurnizor;
	}

	public String getMaConcurenti() {
		return maConcurenti;
	}

	public void setMaConcurenti(String maConcurenti) {
		this.maConcurenti = maConcurenti;
	}

	

	
	
}


 

